Nozzle

Entity Definition

Logical Name : Nozzle
Physical Name : AS_NZL

That part of the FUELING POINT that blends and measures the volume of fuel dispensed during a FUELING TRANSACTION.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer SalesMeter(AS_MTR_SLS)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer FuelingPoint(AS_PNT_FUEL)
FuelingPointID (FK)(PK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer FuelingPoint(AS_PNT_FUEL)
NozzleID (PK) A unique identifier for the Nozzle ID_NZL Identity integer
SalesMeterID (FK) A system-assigned unique identifier for a sales meter. ID_MTR_SLS Identity integer SalesMeter(AS_MTR_SLS)
CurrencyID (FK) The unique identifier of the Currency. ID_CNY Identity integer Currency(CO_CNY)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)

Relationships

Parent Entity Verb Phrase Child Entity
SalesMeter records from Nozzle
Currency applies to Nozzle
FuelingPoint houses Nozzle
ISO4217-CurrencyType is used in Nozzle
Nozzle is summarized to NozzleFuelingTransactionHistory
Nozzle includes SatelliteNozzle
Nozzle is summarized in NozzleHistory
Nozzle is connected to Blender
Nozzle measured FuelingTransaction

Logical Views containing Nozzle

Logical View
Logical 10104 - Enterprise Currency
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20020 - Forecourt Pricing View
Logical 20030 - Forecourt Transaction View
Logical 20040 - Forecourt History View
Logical 20050 - Forecourt Tank Gauge View